Edinburgh’s road network
Edinburgh’s implementation zones
Edinburgh’s control zones
Time series analysis
Mapping accidents with roads: 2013
## LAYER Accident_Index
## 1 20mph existing streets 48
## 2 20mph local streets 72
## 3 20mph main streets 182
## 4 30mph 98
## 5 40mph 43
## 6 50, 60 or 70mph 1
## 7 Part time 20mph 1
## 8 Trunk roads 2
## Speed_limit Accident_Index
## 1 20 25
## 2 30 387
## 3 40 35
Mapping accidents with roads: 2014
## LAYER Accident_Index
## 1 20mph existing streets 154
## 2 20mph local streets 158
## 3 20mph main streets 389
## 4 30mph 266
## 5 40mph 68
## 6 50, 60 or 70mph 14
## 7 Part time 20mph 9
## 8 Trunk roads 5
## Speed_limit Accident_Index
## 1 20 39
## 2 30 955
## 3 40 69
Mapping accidents with roads: 2015
## LAYER Accident_Index
## 1 20mph existing streets 106
## 2 20mph local streets 156
## 3 20mph main streets 327
## 4 30mph 254
## 5 40mph 80
## 6 50, 60 or 70mph 12
## 7 Part time 20mph 6
## 8 Trunk roads 5
## Speed_limit Accident_Index
## 1 20 34
## 2 30 832
## 3 40 80
Mapping accidents with roads: 2016
## LAYER Accident_Index
## 1 20mph existing streets 48
## 2 20mph local streets 57
## 3 20mph main streets 25
## 4 30mph 28
## 5 40mph 17
## Speed_limit Accident_Index
## 1 20 8
## 2 30 148
## 3 40 19
Mapping accidents with roads: 2018
## LAYER Accident_Index
## 1 20mph existing streets 64
## 2 20mph local streets 83
## 3 20mph main streets 181
## 4 30mph 146
## 5 40mph 47
## 6 50, 60 or 70mph 5
## 7 Part time 20mph 7
## 8 Trunk roads 2
## Speed_limit Accident_Index
## 1 20 289
## 2 30 191
## 3 40 55
Mapping accidents with roads: 2019
## LAYER Accident_Index
## 1 20mph existing streets 31
## 2 20mph local streets 51
## 3 20mph main streets 88
## 4 30mph 77
## 5 40mph 24
## 6 50, 60 or 70mph 2
## 7 Part time 20mph 1
## 8 Trunk roads 1
## Speed_limit Accident_Index
## 1 20 153
## 2 30 97
## 3 40 25
Count pre 20mph
## LAYER Accident_Index
## 1 20mph existing streets 356
## 2 20mph local streets 443
## 3 20mph main streets 923
## 4 30mph 646
## 5 40mph 208
## 6 50, 60 or 70mph 27
## 7 Part time 20mph 16
## 8 Trunk roads 12
## Speed_limit Accident_Index
## 1 20 106
## 2 30 2322
## 3 40 203
Count post 20mph
## LAYER Accident_Index
## 1 20mph existing streets 95
## 2 20mph local streets 134
## 3 20mph main streets 269
## 4 30mph 223
## 5 40mph 71
## 6 50, 60 or 70mph 7
## 7 Part time 20mph 8
## 8 Trunk roads 3
## Speed_limit Accident_Index
## 1 20 442
## 2 30 288
## 3 40 80
Output column: Layer
## ID Speed_limit LAYER
## 1 1509 30 30mph
## 2 987 30 20mph main streets
## 3 2505 30 30mph
## 4 1614 30 30mph
## 5 2355 30 30mph
## 6 153 30 20mph main streets
Table: Average annual road traffic collision rates in the city of Edinburgh (GIS)
| Type | collisions pre-20mph | collisions post-20mph | rate pre-20mph | rate post-20mph | diff in rates | Perc.diff.rates |
|---|---|---|---|---|---|---|
| Streets at 30mph | 646 | 223 | 215.33 | 223 | 7.67 | 4 |
| Streets at 20mph | 356 | 95 | 118.67 | 95 | -23.67 | -20 |
| Streets at 30mph changed to 20mph | 1366 | 403 | 455.33 | 403 | -52.33 | -11 |
| Streets at 40mph | 208 | 71 | 69.33 | 71 | 1.67 | 2 |
| All streets | 2576 | 792 | 858.67 | 792 | -66.67 | -8 |
Table: Average annual road traffic collision rates in the city of Edinburgh (Stats19)
| Type | collisions pre-20mph | collisions post-20mph | rate pre-20mph | rate post-20mph | diff in rates | Perc.diff.rates |
|---|---|---|---|---|---|---|
| Streets at 20mph | 106 | 442 | 35.33 | 442 | 406.67 | 1151 |
| Streets at 30mph | 2322 | 288 | 774.00 | 288 | -486.00 | -63 |
| Streets at 40mph | 203 | 80 | 67.67 | 80 | 12.33 | 18 |
| All streets | 2631 | 810 | 877.00 | 810 | -67.00 | -8 |
Effect estimate (GIS)
| Tax year | 2013/14 | 2014/15 | 2015/16 | 2018/19 |
|---|---|---|---|---|
| Annual number of collisions | 1054 | 966 | 611 | 810 |
| Effect estimate | -14.91 |
Effect estimate (Stats19)
| Tax year | 2013/14 | 2014/15 | 2015/16 | 2018/19 |
|---|---|---|---|---|
| Annual number of collisions | 1032 | 945 | 599 | 792 |
| Effect estimate | -14.76 |
Mapping accidents with implementation zones: 2013
## ImplementationZone Accident_Index
## 1 1 73
## 2 2 105
## 3 3 137
## 4 4 44
## 5 5 68
## 6 6 30
## 7 7 21
Mapping accidents with implementation zones: 2014
## ImplementationZone Accident_Index
## 1 1 168
## 2 2 275
## 3 3 298
## 4 4 109
## 5 5 132
## 6 6 89
## 7 7 58
Mapping accidents with implementation zones: 2015
## ImplementationZone Accident_Index
## 1 1 155
## 2 2 210
## 3 3 273
## 4 4 75
## 5 5 144
## 6 6 91
## 7 7 43
Mapping accidents with implementation zones: 2016
## ImplementationZone Accident_Index
## 1 1 96
## 2 2 120
## 3 3 147
## 4 4 48
## 5 5 60
## 6 6 48
## 7 7 24
Mapping accidents with implementation zones: 2018
## ImplementationZone Accident_Index
## 1 1 88
## 2 2 125
## 3 3 160
## 4 4 53
## 5 5 68
## 6 6 46
## 7 7 30
Mapping accidents with implementation zones: 2019
## ImplementationZone Accident_Index
## 1 1 42
## 2 2 68
## 3 3 79
## 4 4 33
## 5 5 27
## 6 6 18
## 7 7 14
Output column: Implementation Zone
## Accident_Index Speed_limit ImplementationZone
## 1 2013950000001 30 1
## 2 2013950000002 30 2
## 3 2013950000003 30 2
## 4 2013950000007 30 1
## 5 2013950000010 30 4
## 6 2013950000058 20 7
Total accidents per zone
## ImplementationZone Accident_Index
## 1 1 622
## 2 2 903
## 3 3 1094
## 4 4 362
## 5 5 499
## 6 6 322
## 7 7 190
Control zone 1a:City center –> George St/Harbour, Aberdeen
## [1] 81
Control zone 1b:Rural west –> Tay Bridgehead & St Andrews
## [1] 60
Control zone 3:South central –> Dundee
## [1] 494
Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West
## [1] 286
Control zone 5:West –> Glasgow Kelvin
## [1] 977
Control zone 6:South –> Paisley
## [1] 391
Updated dataset for Edinburgh
## Accident_Index Speed_limit LAYER ImplementationZone
## 1 0000419 20 20mph main streets 2
## 2 0000519 20 20mph local streets 1
## 3 0000919 40 20mph local streets 3
## 4 0001019 20 30mph 2
## 5 0001219 40 40mph 4
## 6 0001419 30 30mph 4